What is merged results in Looker?

In these cases, Looker lets you combine data from different Explores (even from different models or projects) to create data tables and visualizations. Using the Merged Results feature, you can create a query from an Explore and then add queries from other Explores to display the merged results in a single table.

How do I merge search results with Looker?

Review the dimensions that Looker used to match the queries. Your Primary search on Flights should be using Aircraft Origin City to merge by the Secondary search of Airports on Airports City. Change the dropdowns so that the correct dimensions are used in the merge rule. Click Run to view the results of your merged results.

How do I use the merged results feature?

Using the Merged Results feature, you can create a query from an Explore and then add queries from other Explores to display the merged results in a single table. From there, you can examine the data, pivot fields, and create visualizations. Note: The Merged Results feature has a limit of 5,000 rows of data for each of the merged queries.